UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'F9HP90v0nQfM42vSCEa74BL1VdF3Emogw3fAPSr5FUM='
WHERE
key_id = 'aad482c3610d349c04dba489964ef023374ba9ea5802c8ff6515b6fd263a024a'
AND (
token = 'F9HP90v0nQfM42vSCEa74BL1VdF3Emogw3fAPSr5FUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)