UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27Nlxxm5d92OIieyV1E4NVHwn5qX/uUE3kTGott1g0Y='
WHERE
key_id = 'c24c244eb7b3feaa205a409d73ca7a8a3e0c4097d717f62011b4ca430bf47be6'
AND (
token = '27Nlxxm5d92OIieyV1E4NVHwn5qX/uUE3kTGott1g0Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)