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