UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XFweSzG6gVNkwhz11W/vzGtzjRMmzzNGsgXoBL8vPuM='
WHERE
key_id = 'dad8ae880d6d71ef3b85f27362111bf145f1f4677789d7baeb4f0dd7f1ad0ac6'
AND (
token = 'XFweSzG6gVNkwhz11W/vzGtzjRMmzzNGsgXoBL8vPuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)