UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NVaw5qDVlE+S98+OVZvkqN4lc0nOSv43eA/TWVnP6vU='
WHERE
key_id = '0ab42ee5f0aa0dcd815e1bbdc3021eded22831627fcb8d32d5fea9ab10668aef'
AND (
token = 'NVaw5qDVlE+S98+OVZvkqN4lc0nOSv43eA/TWVnP6vU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)