UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XthQlveBsNK+XGvHUbjR9A70r02BxHJaYAPA7aXFtf0='
WHERE
key_id = '7df824ad046944a9e0826ad27419198ae9cb0ff1f593beffedf449d25f92a565'
AND (
token = 'XthQlveBsNK+XGvHUbjR9A70r02BxHJaYAPA7aXFtf0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)