UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z4JRYW5MtUqYGHIR9zElWKTLZn0NG/J7INb2eqWo46w='
WHERE
key_id = '74afe3ec8f39f36529a6608618cf1b64829367edcb916ec32262c569ec746302'
AND (
token = 'z4JRYW5MtUqYGHIR9zElWKTLZn0NG/J7INb2eqWo46w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)