UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8EToU0JZffrcPOMwpEJUGLDpAvi1Aae1Ccg98pEMDrA='
WHERE
key_id = 'a0f1d8f0bcfb489b3cb49e5101d79d5bf2f85b7321973b149bdad8dc22ce454e'
AND (
token = '8EToU0JZffrcPOMwpEJUGLDpAvi1Aae1Ccg98pEMDrA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)