UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oHGIwNRIVZSKrzIhwWLY0McZvDeZwKtEC+/SUxIXJSU='
WHERE
key_id = '1e41c88529f558b121faa95fa642ae0ccc24a5e9be9690d0ad72183a8372ab9a'
AND (
token = 'oHGIwNRIVZSKrzIhwWLY0McZvDeZwKtEC+/SUxIXJSU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)