UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sGJjrJ5PX8r8otZSf24t3PejhiZcUpw8DLlhb4FnxfA='
WHERE
key_id = '0c9f0fb4131e27274c2923d663f0a4ec631ea73c4de27b76ec15901637fa5908'
AND (
token = 'sGJjrJ5PX8r8otZSf24t3PejhiZcUpw8DLlhb4FnxfA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)