UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hQHIamBvuRBqDcrehpSmghW4TNaqYQy7vp4eHI0/lGQ='
WHERE
key_id = 'a856a443e4bb0867fbb354e56b37e4a20f417cd8d8514cfac1c30a9491684360'
AND (
token = 'hQHIamBvuRBqDcrehpSmghW4TNaqYQy7vp4eHI0/lGQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)