UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9ptZOEvWvK5SulG/riCsMI6DjDnLlFxPTXeUHUXoTE='
WHERE
key_id = '2cad9ad24d5d174c7a68b97e4eafd3e7684ffe40ad096da7c93e5a9861e97694'
AND (
token = 'r9ptZOEvWvK5SulG/riCsMI6DjDnLlFxPTXeUHUXoTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)