UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a7mC64/0znY+e27Qs7iIdBpXBaVVd3kqxenN2/29YyU='
WHERE
key_id = 'c7f07be6323f687826b3813e2309cad1ff013fba762dbebac784cae0f04cc711'
AND (
token = 'a7mC64/0znY+e27Qs7iIdBpXBaVVd3kqxenN2/29YyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)