UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uWs0YXHR159mF7t7Yufpw9M9CnuowZ0xRl8OGBkPmfA='
WHERE
key_id = '34d603358a332c6357ef086d756ee1fccab2d0ed0865f786b008482cd2ed87f7'
AND (
token = 'uWs0YXHR159mF7t7Yufpw9M9CnuowZ0xRl8OGBkPmfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)