UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'My4A23y+DiRsuaxMzONN0LiQYJWCHJItdX3itU5f8+o='
WHERE
key_id = 'ea778b64756b1a377605ec1d1eed2f5137fb1b9fb1ee42981e60a19cc9303938'
AND (
token = 'My4A23y+DiRsuaxMzONN0LiQYJWCHJItdX3itU5f8+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)