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