UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QrSv+wGmRAqRmjwUqPy7DJOdzMWVq4wwyf1mE1D4DLo='
WHERE
key_id = '2a54d7a414119e5d4b8494b73a9eff8a9328beef3a2f40c4b3d830810a13e5a3'
AND (
token = 'QrSv+wGmRAqRmjwUqPy7DJOdzMWVq4wwyf1mE1D4DLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)