UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YSNXD0PYoUD44P0sbYgVc1ocvcq4wE4iMFiP59XwTeE='
WHERE
key_id = '217ba1e6536885024a8411822827e4b4e098d7dcdf6e144bc903b50fb409679f'
AND (
token = 'YSNXD0PYoUD44P0sbYgVc1ocvcq4wE4iMFiP59XwTeE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)