UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'esCZagchUFYURbdQ48TU9FWbuhbME4dBxTy+cV9qoQc='
WHERE
key_id = 'd7cf91f50d9c8194865bc9da9ba0aa1e80f3f2f3f4b1827a7d14b429640e1f23'
AND (
token = 'esCZagchUFYURbdQ48TU9FWbuhbME4dBxTy+cV9qoQc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)