UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '56CAp7nmJZ78Dg6DXLjftD1AI13mQ34yDU1IXDC0+DA='
WHERE
key_id = 'c0e87601d1b7eea82dc92de8b1c97ce49f71273f07343b887cf8ed251dd81546'
AND (
token = '56CAp7nmJZ78Dg6DXLjftD1AI13mQ34yDU1IXDC0+DA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)