UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'an+S31dSmHPDvMqJ7NlE8WWUwGud5EyFgCYHrNEHa3w='
WHERE
key_id = 'e4b1c6f763700a568b4998fcbe425557b7c1ea31c0a0e52c2ca85bd2cd361d52'
AND (
token = 'an+S31dSmHPDvMqJ7NlE8WWUwGud5EyFgCYHrNEHa3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)