UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cPe1952VQX94QlyPzz5NrzRkqKPI/caf7szp6KQ77Iw='
WHERE
key_id = '78d988ada8004013d6cd837a1b004d2280049652cebf09a4c373579c765cf882'
AND (
token = 'cPe1952VQX94QlyPzz5NrzRkqKPI/caf7szp6KQ77Iw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)