UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oN1Lav5g6Eu+o759+xJyQVPWWFnfB46+u2RjETg82B0='
WHERE
key_id = 'c69401e76d1d2a6af43349da054fa04d47b4aff69693f2acf4693debbc8183aa'
AND (
token = 'oN1Lav5g6Eu+o759+xJyQVPWWFnfB46+u2RjETg82B0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)