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