UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JxML9jqovzha0ef/ufCTym6znOc1gOkaZzTockx11Gg='
WHERE
key_id = '847bfc207767d5e02a42e08612aa137c0d8d91d193b36a1307c4f2d58cb98874'
AND (
token = 'JxML9jqovzha0ef/ufCTym6znOc1gOkaZzTockx11Gg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)