UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yYjn4mBtC/bMnff0ZiH96aBvZCv6enG11foN5Ky2DOM='
WHERE
key_id = 'cfe86933b603c6b84645ee5c7f351743c06c34dbf87a77405329f20fc827599f'
AND (
token = 'yYjn4mBtC/bMnff0ZiH96aBvZCv6enG11foN5Ky2DOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)