UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u0sqM2ZdBhthvaAfRSUMZf8UpR5rmNf1NTW5YJVbLUU='
WHERE
key_id = '6d0a5ce4c1271e67b002b713d1ce579cd8e70cddccc657a359ef420f9c3d1fe5'
AND (
token = 'u0sqM2ZdBhthvaAfRSUMZf8UpR5rmNf1NTW5YJVbLUU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)