UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6Bk1fHF5x4l3MP5ioy633SAOzvCjY/5iL2KwidfHcCo='
WHERE
key_id = 'ee42947cdfd74e11477d68c30f42732da1c6b6fd41de4bdc35c3ff9811288aec'
AND (
token = '6Bk1fHF5x4l3MP5ioy633SAOzvCjY/5iL2KwidfHcCo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)