UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QLQygYvee1+R+ITMfmFP0wO+HBKRw2m6/PlPoyX0Aqo='
WHERE
key_id = 'a5402b6c19e5d73766248a7406ea510352a5c96107ae6879145255b9ee860117'
AND (
token = 'QLQygYvee1+R+ITMfmFP0wO+HBKRw2m6/PlPoyX0Aqo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)