UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+OvKW7CeQn1+rSNXogqtf278Jq2vNoMCtRouGS1Hb8U='
WHERE
key_id = 'ca2fa6594762f4c474c113938b3beb64a5ec47850556d5b894a87efa7ee69d72'
AND (
token = '+OvKW7CeQn1+rSNXogqtf278Jq2vNoMCtRouGS1Hb8U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)