UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kXoCNM/vBwqOkdskVIq4/zbTKIh/4YxU/oswqxy0GOE='
WHERE
key_id = '40f09567e4f15b59e5cf535e2398a300c817bad994110df5638152a0724b61c0'
AND (
token = 'kXoCNM/vBwqOkdskVIq4/zbTKIh/4YxU/oswqxy0GOE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)