UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4ljPS9rHOjOZACncgZ32flQLm9FniADcTY3Zw+nXaIQ='
WHERE
key_id = 'fad3528217e6805fac8f048db3574c9216e3454b137ded7226a61f9b27f278a1'
AND (
token = '4ljPS9rHOjOZACncgZ32flQLm9FniADcTY3Zw+nXaIQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)