UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DfPhbNjyJcwa5mQ0nbdvGEpNkzl/DdrbtZhTGmt9I6w='
WHERE
key_id = 'a2aa3487487dd6c40bc226fa8fa1fed1a1b4afeb7cc958dee1ff07e360829ef4'
AND (
token = 'DfPhbNjyJcwa5mQ0nbdvGEpNkzl/DdrbtZhTGmt9I6w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)