UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mnFDhrwEAzdI9U0XYYzS163NYlM4L9f530YpeIWxYQY='
WHERE
key_id = 'c3aa0aae83b143b9a9c4f00124f4455794787ac140030a29f3823dd8fe4db202'
AND (
token = 'mnFDhrwEAzdI9U0XYYzS163NYlM4L9f530YpeIWxYQY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)